package com.briup.srms.sms.dao.extend;

import java.util.List;

import com.briup.srms.sms.bean.StudentAttendance;
import com.briup.srms.sms.bean.extend.StudentAttendanceExtend;
import com.briup.srms.sms.bean.extend.StudentWithAttendance;

public interface StudentAttendanceExtendMapper {
	
	List<StudentAttendanceExtend> query(int page,int pageSize,String realname,Long directionId,Long clazzId,String[] statuses,String attendanceDateStr,String stage);
	
	long count(String realname,Long directionId,Long clazzId,String[] statuses,String attendanceDateStr,String stage);

	List<StudentAttendanceExtend> queryTrain(int page, int pageSize, String realname, Long trainId, Long channelId,String attendanceDateStr);

	long countTrain(String realname, Long trainId, Long channelId,String attendanceDateStr);

	List<StudentWithAttendance> queryStudentLeftJoinAttendance(int page,int pageSize,Long channelId,Long directionId,Long clazzId,Long startTime,Long endTime);
	
	long countStudentLeftJoinAttendance(Long channelId,Long directionId,Long clazzId,Long startTime,Long endTime);
	
	List<StudentAttendance> queryAttendance(Long startTime,Long endTime,Long studentId);
}
